Show All
WrapText property as it applies to the Style object.
True if Microsoft Excel wraps the text in the object. Read/write Boolean.
expression.WrapText
expression Required. An expression that returns one of the above objects.
WrapText property as it applies to the CellFormat and Range objects.
True if Microsoft Excel wraps the text in the object. Returns Null if the specified range contains some cells that wrap text and other cells that don’t. Read/write Variant.
expression.WrapText
expression Required. An expression that returns one of the above objects.
Microsoft Excel will change the row height of the range, if necessary, to accommodate the text in the range.
As it applies to the Range object.
This example formats cell B2 on Sheet1 so that the text wraps within the cell.
Worksheets("Sheet1").Range("B2").Value = _
"This text should wrap in a cell."
Worksheets("Sheet1").Range("B2").WrapText = True